package com.wmh.baseservice.operationaid.entity;

import com.baomidou.mybatisplus.annotation.*;
import lombok.Data;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDateTime;

/**
 * 运营助手-商品数据-流量来源
 * @author 谢骏
 * @TableName operation_aid_product_trafficsource
 * @createDate 2023-07-21 11:08:42
 */
@Data
@Accessors(chain = true)
@TableName("operation_aid_product_trafficsource")
public class ProductTrafficSource implements Serializable {

    /**
     * 主键
     */
    @TableId(value = COL_ID ,type = IdType.AUTO)
    private Long id;

    /**
     * 店铺名称
     */
    @TableField(value = COL_STORE_NAME)
    private String storeName;

    /**
     * 流量来源
     */
    @TableField(value = COL_TRAFFICS_SOURCE)
    private String trafficsSource;

    /**
     * 数据周期
     */
    @TableField(value = COL_DATA_CYCLE)
    private String dataCycle;

    /**
     * 商品标题
     */
    @TableField(value = COL_PRODUCT_TITLE)
    private String productTitle;

    /**
     * 商品编号
     */
    @TableField(value = COL_PRODUCT_ID)
    private Long productId;

    /**
     * 访客数
     */
    @TableField(value = COL_VISITOR_NUM)
    private Integer visitorNum;

    /**
     * 下单买家数
     */
    @TableField(value = COL_BUYERS_NUM)
    private Integer buyersNum;

    /**
     * 下单转化率
     */
    @TableField(value = COL_ORDER_CVS_RATE)
    private BigDecimal orderCvsRate;

    /**
     * 浏览量
     */
    @TableField(value = COL_PAGE_VIEW)
    private Integer pageView;

    /**
     * 浏览量占比
     */
    @TableField(value = COL_PERCENTAGE_OF_PAGE_VIEWS)
    private BigDecimal percentageOfPageViews;

    /**
     * 店内跳转人数
     */
    @TableField(value = COL_IN_STORE_JUMP)
    private Integer inStoreJump;

    /**
     * 跳出本店人数
     */
    @TableField(value = COL_OUT_STORE_JUMP)
    private Integer outStoreJump;

    /**
     * 收藏人数
     */
    @TableField(value = COL_COLLECTOR_NUM)
    private Integer collectorNum;

    /**
     * 收藏率
     */
    @TableField(value = COL_COLLECTION_RATE)
    private BigDecimal collectionRate;

    /**
     * 加购人数
     */
    @TableField(value = COL_ADDITIONAL_PURCHASE)
    private Integer additionalPurchase;

    /**
     * 加购率
     */
    @TableField(value = COL_ADDITION_RATE)
    private BigDecimal additionRate;

    /**
     * 支付件数
     */
    @TableField(value = COL_PAYOUTS_NUM)
    private Integer payoutsNum;

    /**
     * 支付买家数
     */
    @TableField(value = COL_PAID_BUYERS_NUM)
    private Integer paidBuyersNum;

    /**
     * 支付金额
     */
    @TableField(value = COL_AMOUNT_PAID)
    private BigDecimal amountPaid;

    /**
     * 支付转化率
     */
    @TableField(value = COL_PAY_CVS_RATE)
    private BigDecimal payCvsRate;

    /**
     * 直接支付买家数
     */
    @TableField(value = COL_DIRECT_PAY_BUYERS_NUM)
    private Integer directPayBuyersNum;

    /**
     * 收藏后支付买家数
     */
    @TableField(value = COL_PAY_AFTER_COLLECTION_BUYERS_NUM)
    private Integer payAfterCollectionBuyersNum;

    /**
     * 粉丝支付买家数
     */
    @TableField(value = COL_PAY_AFTER_ATTENTION_BUYERS_NUM)
    private Integer payAfterAttentionBuyersNum;

    /**
     * 加购商品-支付买家数
     */
    @TableField(value = COL_BUY_MORE_BUYERS_NUM)
    private Integer buyMoreBuyersNum;

    /**
     * 客单价
     */
    @TableField(value = COL_PER_CUSTOMER)
    private BigDecimal perCustomer;

    /**
     * uv价值
     */
    @TableField(value = COL_UV_VALUE)
    private BigDecimal uvValue;

    /**
     * 创建时间
     */
    @TableField(value = COL_CREATE_TIME)
    private LocalDateTime createTime;

    /**
     * 更新时间
     */
    @TableField(value = COL_UPDATE_TIME)
    private LocalDateTime updateTime;

    /**
     * 是否删除 0 否 1是
     */
    @TableField(value = COL_DELETED)
    @TableLogic
    private Integer deleted;


    /**
     * 主键
     */
    public static final String COL_ID = "id";

    /**
     * 店铺名称
     */
    public static final String COL_STORE_NAME = "store_name";

    /**
     * 流量来源
     */
    public static final String COL_TRAFFICS_SOURCE = "traffics_source";

    /**
     * 数据周期
     */
    public static final String COL_DATA_CYCLE = "data_cycle";

    /**
     * 商品标题
     */
    public static final String COL_PRODUCT_TITLE = "product_title";

    /**
     * 商品编号
     */
    public static final String COL_PRODUCT_ID = "product_id";

    /**
     * 访客数
     */
    public static final String COL_VISITOR_NUM = "visitor_num";

    /**
     * 下单买家数
     */
    public static final String COL_BUYERS_NUM = "buyers_num";

    /**
     * 下单转化率
     */
    public static final String COL_ORDER_CVS_RATE = "order_cvs_rate";

    /**
     * 浏览量
     */
    public static final String COL_PAGE_VIEW = "page_view";

    /**
     * 浏览量占比
     */
    public static final String COL_PERCENTAGE_OF_PAGE_VIEWS= "percentage_of_page_views";

    /**
     * 店内跳转人数
     */
    public static final String COL_IN_STORE_JUMP = "in_store_jump";

    /**
     * 跳出本店人数
     */
    public static final String COL_OUT_STORE_JUMP = "out_store_jump";

    /**
     * 收藏人数
     */
    public static final String COL_COLLECTOR_NUM = "collector_num";

    /**
     * 收藏率
     */
    public static final String COL_COLLECTION_RATE = "collection_rate";

    /**
     * 加购人数
     */
    public static final String COL_ADDITIONAL_PURCHASE = "additional_purchase";

    /**
     * 加购率
     */
    public static final String COL_ADDITION_RATE = "addition_rate";

    /**
     * 支付件数
     */
    public static final String COL_PAYOUTS_NUM = "payouts_num";

    /**
     * 支付买家数
     */
    public static final String COL_PAID_BUYERS_NUM = "paid_buyers_num";

    /**
     * 支付金额
     */
    public static final String COL_AMOUNT_PAID = "amount_paid";

    /**
     * 支付转化率
     */
    public static final String COL_PAY_CVS_RATE = "pay_cvs_rate";

    /**
     * 直接支付买家数
     */
    public static final String COL_DIRECT_PAY_BUYERS_NUM = "direct_pay_buyers_num";

    /**
     * 收藏后支付买家数
     */
    public static final String COL_PAY_AFTER_COLLECTION_BUYERS_NUM = "pay_after_collection_buyers_num";

    /**
     * 粉丝支付买家数
     */
    public static final String COL_PAY_AFTER_ATTENTION_BUYERS_NUM = "pay_after_attention_buyers_num";

    /**
     * 加购商品-支付买家数
     */
    public static final String COL_BUY_MORE_BUYERS_NUM = "buy_more_buyers_num";

    /**
     * 客单价
     */
    public static final String COL_PER_CUSTOMER = "per_customer";

    /**
     * uv价值
     */
    public static final String COL_UV_VALUE = "uv_value";

    /**
     * 创建时间
     */
    public static final String COL_CREATE_TIME = "create_time";

    /**
     * 更新时间
     */
    public static final String COL_UPDATE_TIME = "update_time";

    /**
     * 是否删除 0 否 1是
     */
    public static final String COL_DELETED = "deleted";

    @TableField(exist = false)
    static final long serialVersionUID = 1L;
}
